COVID-19

How does it compare?

---

Erin Wright

---

Confirmed Cases (US)

Influenza¹

Is the trend of cumulative confirmed COVID-19² cases really higher than that of Influenza?

Cause of Death (US)

How does the reported COVID-19 data compare to other causes of death?³

Consideration must be given to the fact that COVID-19 data only represents a portion of a year whereas the other causes have all data from 2018 included. Data was adjusted to represent rates per 100,000 population⁴. To do this the total number of deaths was divided by the number of groups of 100,000 persons present in the population using the 2018 US population estimate of 327274411.

Since COVID-19 has been accumulating over less than a year, what if we calculate the death rate using both population and days accumulating? So if we take the death rate calculated above then multiply by the fraction of a year represented by the data, it might be closer to a far comparison;for other than COVID-19 this would be just 1, for COVID-19 this would be 365 divided by virus days passed.

Locations

Where was the first report in each country?

Where did it spread

This gets a little busy, but is still very neat to look at; if we take the first location the virus is known to have landed (confirmed cases) in each country, and follow it country:country we get this:

How fast did it spread?

Day of Virus represents the first day a reported case is docuemnted for each country listed.

Country Populations

How does the reported COVID-19 data compare across the globe?

When taking into account the overall population of each of the following countries, what is the impact for each?⁵.

What about age?⁶

Is the country median age related to the total cumulative deaths for % country population?

Credits

I used these sources to build the graphics in this report:

• Maps: https://rstudio-pubs-static.s3.amazonaws.com/259095_2f8cb24b43284692a8af916bd447931d.html
• Plotly in R: https://plotly.com/r/line-charts/
• Sub Plots: https://stackoverflow.com/questions/56267164/r-plotly-subplot-with-table

SOURCE CODE

Report Date: 2020-04-17

---

1. Data Source: https://gis.cdc.gov/grasp/fluview/flu_by_age_virus.html↩︎

2. Data Source: https://github.com/CSSEGISandData/COVID-19↩︎

3. Data Source: https://www.cdc.gov/nchs/pressroom/stats_of_the_states.htm↩︎

4. Data Source: https://data.worldbank.org/indicator/sp.pop.totl↩︎

5. Data Source: https://data.worldbank.org/indicator/sp.pop.totl↩︎

6. Data Source: https://www.cia.gov/library/publications/the-world-factbook/↩︎